Problem Note 32417: Netezza returns an error if a connection is read-only and you try to use that connection to create a table
When you use SAS/ACCESS® Interface to ODBC with Netezza's ODBC driver and you have the options CONNECTION=SHARED or CONNECTION=GLOBAL, certain operations cause the shared connection to be read-only. If you then try to use that connection to create a table, Netezza returns the following error:
Error attempting to CREATE a DBMS table.
ERROR: CLI execute error: Connection is readonly, only select statements are allowed.
As a workaround, you should use one LIBNAME statement for global operations (specifically, for temporary tables) and another LIBNAME statement for other operations (for example, creating permanent tables or inserting data into permanent tables).
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to ODBC | Solaris for x64 | 9.2 TS1M0 | 9.2 TS2M0 |
| Linux | 9.2 TS1M0 | 9.2 TS2M0 |
| HP-UX IPF | 9.2 TS1M0 | 9.2 TS2M0 |
| 64-bit Enabled Solaris | 9.2 TS1M0 | 9.2 TS2M0 |
| 64-bit Enabled HP-UX | 9.2 TS1M0 | 9.2 TS2M0 |
| 64-bit Enabled AIX | 9.2 TS1M0 | 9.2 TS2M0 |
| Windows Vista | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows XP Professional | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 |
| Linux for x64 | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
When you use SAS/ACCESS
® Interface to ODBC with Netezza's ODBC driver and you have the options CONNECTION=SHARED or CONNECTION=GLOBAL, certain operations cause the shared connection to be read-only. If you then try to use that connection to create a table, Netezza returns an error.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2008-09-22 15:20:58 |
| Date Created: | 2008-06-11 14:19:41 |
